Customer Transactions Report

If this were a real report I would welcome the reader here and provide any context they require.

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.

Distribution of overdraft limits

Relationship between account open and close dates

As can be seen in Figure 1, the rate of new accounts being opened is on a downward trend.

Figure 1: Number of accounts opening per month after adjusting for account closures

The trend is because while the number of accounts being opened between 2002 and 2018 have remained roughly steady, during the same period the number of accounts closing each month has been slowly rising, as seen in Figure 2.

Figure 2: Number of accounts opening (top line) and closing (bottom line) per month

Customers

Highest transaction value

The customer with the highest overall transaction value is account number 11336875, with £423,496.

Highest number of transactions

The 10 customers with the highest number of transactions are

Account Number	Transactions Count
11336875	693
12402243	686
10322173	500
12644022	472
10250507	468
10143829	426
11850488	424
10709272	421
12822022	402
11358265	386

Lowest transaction value

The customer with the lowest overall transaction value is account number 12857039, with £-50,165.

Transactions per month

Number Customers	Month
3,787	Jan 2018
3,687	Feb 2018
3,846	Mar 2018
3,776	Apr 2018
3,797	May 2018
3,782	Jun 2018
3,826	Jul 2018
3,776	Aug 2018
3,758	Sep 2018
3,845	Oct 2018
3,157	Nov 2018

No transactions

There are 3,463 customers with no transactions.